-
Re: Count if & Unique Values?
Try this, =COUNT(DISTINCT(COLLECT([Item]:[Item],[Frequency]:[Frequency], "Monthly")))1 · -
Re: How to SUMIF in Smartsheet with multiple criteria requirements from one column
Make sure you replace the columns names correctly and also the row numbers as appropriate in your sheet =SUMIF([Your Status Column Name]40:[Your Status Column Name]79, OR(@cell = "Estimated"…1 · -
Re: Using Collect with the large function
Use the corrected formula below, =INDEX(COLLECT(Name61:Name131, [Total Issues]61:[Total Issues]131, LARGE([Total Issues]61:[Total Issues]131, 1)),1)1 · -
Add functionality to Move folders and other SS objects across Workspaces
There is no menu option today in the interface to move objects across Workspaces in SS. DND is undocumented and not consistent across the browsers.1 · -
Increase the no. of posts displayed per page
It will be great if the number of posts per page can be increased from current 10 posts per page to 25 or so? Could be something that be a default across community forum or an option in user preferen…3 ·